package com.fowo.api.model.walmart.listing;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.common.excel.ImageConvert;
import com.fowo.api.sys.entity.SysFile;
import java.util.List;
import javax.validation.constraints.*;
import lombok.Getter;
import lombok.Setter;

/** 沃尔玛在线商品 导入导出辅助模型 */
@Getter
@Setter
public class WalmartListingExcelPo {

  @Size(max = 1000, message = "主图地址长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "主图地址")
  private String primaryImageUrl;

  @Size(max = 50, message = "商品ID长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "商品ID")
  private String itemId;

  @Size(max = 50, message = "MSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "MSKU")
  private String msku;

  @Size(max = 5000, message = "标题长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "标题")
  private String title;

  @Size(max = 50, message = "品名长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "品名")
  private String localName;

  @Size(max = 50, message = "SKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "SKU")
  private String localSku;

  @Size(max = 50, message = "状态长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "状态")
  private String publishedStatus;

  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "店铺")
  private String sidShopName;

  @ExcelIgnore
  @ExcelProperty(value = "店铺")
  private Long sid;

  @Size(max = 50, message = "价格币种长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "价格币种")
  private String priceCurrency;

  @Size(max = 50, message = "价格长度不能超过20")
  @ExcelProperty(value = "价格")
  private java.math.BigDecimal priceAmount;

  @ExcelProperty(value = "非WFS可售")
  private Integer noWfsVendibility;

  @ExcelProperty(value = "WFS可售")
  private Integer wfsVendibility;

  @ExcelProperty(value = "Buy Box 价格")
  private java.math.BigDecimal buyBoxItemPrice;

  @ExcelProperty(value = "Buy Box 运费")
  private java.math.BigDecimal buyBoxShippingPrice;

  @Size(max = 50, message = "GTIN长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "GTIN")
  private String gtin;

  @Size(max = 50, message = "UPC长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "UPC")
  private String upc;

  @Size(max = 50, message = "商品税号长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "商品税号")
  private String productTaxCode;

  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "销售开始日期")
  private java.util.Date offerStartDate;

  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "销售结束日期")
  private java.util.Date offerEndDate;

  @ExcelProperty(value = "评论数")
  private Integer reviewsCount;

  @Size(max = 50, message = "评分长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "评分")
  private String averageRating;

  @Size(max = 50, message = "品牌长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "品牌")
  private String brand;

  @Size(max = 50, message = "发货方式长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "发货方式")
  private String fulfillmentType;

  @Size(max = 50, message = "竞争商品价格长度不能超过20")
  @ExcelProperty(value = "竞争商品价格")
  private java.math.BigDecimal competitorPrice;

  @Size(max = 50, message = "竞争商品运费长度不能超过20")
  @ExcelProperty(value = "竞争商品运费")
  private java.math.BigDecimal competitorShipPrice;

  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "创建时间")
  private java.util.Date itemCreationDate;

  @DateTimeFormat("yyyy年MM月dd日")
  @ExcelProperty(value = "更新时间")
  private java.util.Date itemLastUpdated;

  @ExcelProperty(value = "图片", converter = ImageConvert.class)
  private List<SysFile> image;
}
